/ CD-ROM Windows Selection / Windows Selection 1.iso / Multimedia Utilities / AF3_Demo / FM_AF3.DLL / STR_ / 8

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 2f 00 3c 22 5e 30 22 20 | 63 61 6e 6e 6f 74 20 62 |/.<"^0" |cannot b|
|00000010| 65 20 64 65 6c 65 74 65 | 64 20 62 65 63 61 75 73 |e delete|d becaus|
|00000020| 65 20 69 74 20 69 73 20 | 75 73 65 64 20 62 79 20 |e it is |used by |
|00000030| 74 68 65 20 66 69 65 6c | 64 20 22 5e 31 22 2e 3d |the fiel|d "^1".=|
|00000040| 22 5e 30 22 20 63 61 6e | 6e 6f 74 20 62 65 20 64 |"^0" can|not be d|
|00000050| 65 6c 65 74 65 64 20 62 | 65 63 61 75 73 65 20 69 |eleted b|ecause i|
|00000060| 74 20 69 73 20 75 73 65 | 64 20 69 6e 20 74 68 65 |t is use|d in the|
|00000070| 20 73 63 72 69 70 74 20 | 22 5e 31 22 2e 43 22 5e | script |"^1".C"^|
|00000080| 30 22 20 63 61 6e 6e 6f | 74 20 62 65 20 64 65 6c |0" canno|t be del|
|00000090| 65 74 65 64 20 62 65 63 | 61 75 73 65 20 69 74 20 |eted bec|ause it |
|000000a0| 69 73 20 75 73 65 64 20 | 62 79 20 74 68 65 20 22 |is used |by the "|
|000000b0| 5e 31 22 20 72 65 6c 61 | 74 69 6f 6e 73 68 69 70 |^1" rela|tionship|
|000000c0| 2e 73 46 69 65 6c 64 20 | 6e 61 6d 65 73 20 6d 75 |.sField |names mu|
|000000d0| 73 74 20 62 65 20 62 65 | 74 77 65 65 6e 20 31 20 |st be be|tween 1 |
|000000e0| 61 6e 64 20 36 30 20 63 | 68 61 72 61 63 74 65 72 |and 60 c|haracter|
|000000f0| 73 2e 20 20 50 6c 65 61 | 73 65 20 74 79 70 65 20 |s.  Plea|se type |
|00000100| 61 20 76 61 6c 69 64 20 | 66 69 65 6c 64 20 6e 61 |a valid |field na|
|00000110| 6d 65 20 62 65 66 6f 72 | 65 20 63 6c 69 63 6b 69 |me befor|e clicki|
|00000120| 6e 67 20 74 68 65 20 63 | 72 65 61 74 65 20 62 75 |ng the c|reate bu|
|00000130| 74 74 6f 6e 2e 22 54 68 | 65 20 66 69 65 6c 64 20 |tton."Th|e field |
|00000140| 6e 61 6d 65 20 22 5e 31 | 22 20 69 73 20 6e 6f 74 |name "^1|" is not|
|00000150| 20 75 6e 69 71 75 65 2e | 48 54 68 69 73 20 6c 6f | unique.|HThis lo|
|00000160| 6f 6b 75 70 20 75 73 65 | 73 20 74 68 65 20 66 69 |okup use|s the fi|
|00000170| 65 6c 64 20 22 5e 30 22 | 20 69 6e 20 69 74 73 20 |eld "^0"| in its |
|00000180| 64 65 66 69 6e 69 74 69 | 6f 6e 2e 20 43 68 6f 6f |definiti|on. Choo|
|00000190| 73 65 20 61 6e 6f 74 68 | 65 72 20 66 69 65 6c 64 |se anoth|er field|
|000001a0| 2e 53 54 68 65 20 63 61 | 6c 63 75 6c 61 74 69 6f |.SThe ca|lculatio|
|000001b0| 6e 20 72 65 73 75 6c 74 | 20 74 79 70 65 20 6f 66 |n result| type of|
|000001c0| 20 22 5e 30 22 20 63 61 | 6e 6e 6f 74 20 62 65 20 | "^0" ca|nnot be |
|000001d0| 63 68 61 6e 67 65 64 20 | 62 65 63 61 75 73 65 20 |changed |because |
|000001e0| 22 5e 30 22 20 69 73 20 | 75 73 65 64 20 62 79 20 |"^0" is |used by |
|000001f0| 22 5e 31 22 2e 46 54 68 | 65 20 66 69 65 6c 64 20 |"^1".FTh|e field |
|00000200| 74 79 70 65 20 6f 66 20 | 22 5e 30 22 20 63 61 6e |type of |"^0" can|
|00000210| 6e 6f 74 20 62 65 20 63 | 68 61 6e 67 65 64 20 62 |not be c|hanged b|
|00000220| 65 63 61 75 73 65 20 22 | 5e 30 22 20 69 73 20 75 |ecause "|^0" is u|
|00000230| 73 65 64 20 62 79 20 22 | 5e 31 22 2e 4d 54 68 65 |sed by "|^1".MThe|
|00000240| 20 66 69 65 6c 64 20 79 | 6f 75 20 73 65 6c 65 63 | field y|ou selec|
|00000250| 74 20 6d 75 73 74 20 62 | 65 20 61 20 54 65 78 74 |t must b|e a Text|
|00000260| 2c 20 4e 75 6d 62 65 72 | 2c 20 44 61 74 65 2c 20 |, Number|, Date, |
|00000270| 54 69 6d 65 20 6f 72 20 | 43 61 6c 63 75 6c 61 74 |Time or |Calculat|
|00000280| 69 6f 6e 20 66 69 65 6c | 64 2e 4a 54 68 69 73 20 |ion fiel|d.JThis |
|00000290| 66 6f 72 6d 75 6c 61 20 | 69 73 20 74 6f 6f 20 6c |formula |is too l|
|000002a0| 6f 6e 67 20 74 6f 20 62 | 65 20 63 61 6c 63 75 6c |ong to b|e calcul|
|000002b0| 61 74 65 64 2e 20 20 42 | 72 65 61 6b 20 69 74 20 |ated.  B|reak it |
|000002c0| 75 70 20 69 6e 74 6f 20 | 74 77 6f 20 66 6f 72 6d |up into |two form|
|000002d0| 75 6c 61 73 2e 89 49 6e | 20 41 56 45 52 41 47 45 |ulas..In| AVERAGE|
|000002e0| 2c 20 43 4f 55 4e 54 2c | 20 45 58 54 45 4e 44 2c |, COUNT,| EXTEND,|
|000002f0| 20 47 45 54 52 45 50 45 | 54 49 54 49 4f 4e 2c 20 | GETREPE|TITION, |
|00000300| 4d 41 58 2c 20 4d 49 4e | 2c 20 4e 50 56 2c 20 53 |MAX, MIN|, NPV, S|
|00000310| 54 44 45 56 2c 20 53 55 | 4d 20 6f 72 20 47 45 54 |TDEV, SU|M or GET|
|00000320| 53 55 4d 4d 41 52 59 2c | 20 61 6e 20 65 78 70 72 |SUMMARY,| an expr|
|00000330| 65 73 73 69 6f 6e 20 77 | 61 73 20 66 6f 75 6e 64 |ession w|as found|
|00000340| 20 77 68 65 72 65 20 61 | 20 66 69 65 6c 64 20 61 | where a| field a|
|00000350| 6c 6f 6e 65 20 69 73 20 | 6e 65 65 64 65 64 2e 2e |lone is |needed..|
|00000360| 54 68 65 72 65 20 61 72 | 65 20 74 6f 6f 20 66 65 |There ar|e too fe|
|00000370| 77 20 73 65 70 61 72 61 | 74 6f 72 73 20 69 6e 20 |w separa|tors in |
|00000380| 74 68 69 73 20 66 75 6e | 63 74 69 6f 6e 2e 2f 54 |this fun|ction./T|
|00000390| 68 65 72 65 20 61 72 65 | 20 74 6f 6f 20 6d 61 6e |here are| too man|
|000003a0| 79 20 73 65 70 61 72 61 | 74 6f 72 73 20 69 6e 20 |y separa|tors in |
|000003b0| 74 68 69 73 20 66 75 6e | 63 74 69 6f 6e 2e 26 54 |this fun|ction.&T|
|000003c0| 68 65 72 65 20 61 72 65 | 20 6d 6f 72 65 20 22 29 |here are| more ")|
|000003d0| 22 20 74 68 61 6e 20 74 | 68 65 72 65 20 61 72 65 |" than t|here are|
|000003e0| 20 22 28 22 2e 26 54 68 | 65 72 65 20 61 72 65 20 | "(".&Th|ere are |
|000003f0| 6d 6f 72 65 20 22 28 22 | 20 74 68 61 6e 20 74 68 |more "("| than th|
|00000400| 65 72 65 20 61 72 65 20 | 22 29 22 2e 3d 41 20 6e |ere are |")".=A n|
|00000410| 75 6d 62 65 72 2c 20 74 | 65 78 74 20 63 6f 6e 73 |umber, t|ext cons|
|00000420| 74 61 6e 74 2c 20 66 69 | 65 6c 64 20 6e 61 6d 65 |tant, fi|eld name|
|00000430| 2c 20 6f 72 20 22 28 22 | 20 69 73 20 65 78 70 65 |, or "("| is expe|
|00000440| 63 74 65 64 20 68 65 72 | 65 2e 31 41 6e 20 6f 70 |cted her|e.1An op|
|00000450| 65 72 61 74 6f 72 20 28 | 65 2e 67 2e 20 2b 2c 20 |erator (|e.g. +, |
|00000460| 2d 2c 20 2a 2c 20 2e 2e | 2e 29 20 69 73 20 65 78 |-, *, ..|.) is ex|
|00000470| 70 65 63 74 65 64 20 68 | 65 72 65 2e 5c 45 69 74 |pected h|ere.\Eit|
|00000480| 68 65 72 20 61 6e 20 6f | 70 65 72 61 74 6f 72 20 |her an o|perator |
|00000490| 77 61 73 20 6f 6d 69 74 | 74 65 64 2c 20 74 68 69 |was omit|ted, thi|
|000004a0| 73 20 66 75 6e 63 74 69 | 6f 6e 20 63 61 6e 6e 6f |s functi|on canno|
|000004b0| 74 20 62 65 20 66 6f 75 | 6e 64 2c 20 6f 72 20 22 |t be fou|nd, or "|
|000004c0| 28 22 20 77 61 73 20 6e | 6f 74 20 65 78 70 65 63 |(" was n|ot expec|
|000004d0| 74 65 64 20 68 65 72 65 | 2e 20 54 68 69 73 20 6e |ted here|. This n|
|000004e0| 75 6d 62 65 72 20 63 61 | 6e 6e 6f 74 20 62 65 20 |umber ca|nnot be |
|000004f0| 65 76 61 6c 75 61 74 65 | 64 2e 1b 54 68 69 73 20 |evaluate|d..This |
|00000500| 66 69 65 6c 64 20 63 61 | 6e 6e 6f 74 20 62 65 20 |field ca|nnot be |
|00000510| 66 6f 75 6e 64 2e 16 54 | 68 69 73 20 66 69 65 6c |found..T|his fiel|
|00000520| 64 20 69 73 20 69 6e 76 | 61 6c 69 64 2e 5b 54 68 |d is inv|alid.[Th|
|00000530| 69 73 20 74 65 78 74 20 | 63 6f 6e 73 74 61 6e 74 |is text |constant|
|00000540| 20 64 6f 65 73 20 6e 6f | 74 20 65 6e 64 20 77 69 | does no|t end wi|
|00000550| 74 68 20 61 20 71 75 6f | 74 61 74 69 6f 6e 20 6d |th a quo|tation m|
|00000560| 61 72 6b 20 28 22 29 20 | 6f 72 20 69 73 20 6c 6f |ark (") |or is lo|
|00000570| 6e 67 65 72 20 74 68 61 | 6e 20 32 35 33 20 63 68 |nger tha|n 253 ch|
|00000580| 61 72 61 63 74 65 72 73 | 2e 6c 54 68 69 73 20 65 |aracters|.lThis e|
|00000590| 78 70 72 65 73 73 69 6f | 6e 20 69 73 20 74 6f 6f |xpressio|n is too|
|000005a0| 20 63 6f 6d 70 6c 69 63 | 61 74 65 64 2e 20 47 45 | complic|ated. GE|
|000005b0| 54 53 55 4d 4d 41 52 59 | 20 66 75 6e 63 74 69 6f |TSUMMARY| functio|
|000005c0| 6e 73 20 63 61 6e 6e 6f | 74 20 62 65 20 6e 65 73 |ns canno|t be nes|
|000005d0| 74 65 64 20 77 69 74 68 | 69 6e 20 6f 74 68 65 72 |ted with|in other|
|000005e0| 20 47 45 54 53 55 4d 4d | 41 52 59 20 66 75 6e 63 | GETSUMM|ARY func|
|000005f0| 74 69 6f 6e 73 2e 4f 4f | 6e 6c 79 20 53 75 6d 6d |tions.OO|nly Summ|
|00000600| 61 72 79 20 66 69 65 6c | 64 73 20 61 72 65 20 61 |ary fiel|ds are a|
|00000610| 6c 6c 6f 77 65 64 20 61 | 73 20 74 68 65 20 66 69 |llowed a|s the fi|
|00000620| 72 73 74 20 61 72 67 75 | 6d 65 6e 74 20 69 6e 20 |rst argu|ment in |
|00000630| 61 20 47 45 54 53 55 4d | 4d 41 52 59 20 66 75 6e |a GETSUM|MARY fun|
|00000640| 63 74 69 6f 6e 2e 79 54 | 68 65 20 73 65 63 6f 6e |ction.yT|he secon|
|00000650| 64 20 61 72 67 75 6d 65 | 6e 74 20 69 6e 20 61 20 |d argume|nt in a |
|00000660| 47 45 54 53 55 4d 4d 41 | 52 59 20 66 75 6e 63 74 |GETSUMMA|RY funct|
|00000670| 69 6f 6e 20 63 61 6e 6e | 6f 74 20 62 65 20 61 20 |ion cann|ot be a |
|00000680| 53 75 6d 6d 61 72 79 20 | 66 69 65 6c 64 20 75 6e |Summary |field un|
|00000690| 6c 65 73 73 20 69 74 20 | 69 73 20 74 68 65 20 73 |less it |is the s|
|000006a0| 61 6d 65 20 66 69 65 6c | 64 20 61 73 20 74 68 65 |ame fiel|d as the|
|000006b0| 20 66 69 72 73 74 20 61 | 72 67 75 6d 65 6e 74 2e | first a|rgument.|
|000006c0| 2e 54 68 69 73 20 63 6f | 6e 73 74 61 6e 74 20 69 |.This co|nstant i|
|000006d0| 73 20 6e 6f 74 20 61 20 | 72 65 63 6f 67 6e 69 7a |s not a |recogniz|
|000006e0| 65 64 20 73 74 61 74 75 | 73 20 66 6c 61 67 2e 47 |ed statu|s flag.G|
|000006f0| 54 68 65 20 73 75 6d 6d | 61 72 69 7a 65 64 20 66 |The summ|arized f|
|00000700| 69 65 6c 64 20 6d 75 73 | 74 20 62 65 20 61 20 4e |ield mus|t be a N|
|00000710| 75 6d 62 65 72 2c 20 44 | 61 74 65 2c 20 54 69 6d |umber, D|ate, Tim|
|00000720| 65 20 6f 72 20 43 61 6c | 63 75 6c 61 74 69 6f 6e |e or Cal|culation|
|00000730| 20 66 69 65 6c 64 2e 4c | 54 68 69 73 20 66 69 65 | field.L|This fie|
|00000740| 6c 64 20 63 61 6e 6e 6f | 74 20 62 65 20 75 73 65 |ld canno|t be use|
|00000750| 64 20 68 65 72 65 20 62 | 65 63 61 75 73 65 20 69 |d here b|ecause i|
|00000760| 74 20 77 6f 75 6c 64 20 | 63 61 75 73 65 20 61 20 |t would |cause a |
|00000770| 63 69 72 63 75 6c 61 72 | 20 64 65 66 69 6e 69 74 |circular| definit|
|00000780| 69 6f 6e 2e 36 50 65 72 | 6d 61 6e 65 6e 74 6c 79 |ion.6Per|manently|
|00000790| 20 64 65 6c 65 74 65 20 | 74 68 69 73 20 66 69 65 | delete |this fie|
|000007a0| 6c 64 20 61 6e 64 20 41 | 4c 4c 20 6f 66 20 69 74 |ld and A|LL of it|
|000007b0| 73 20 63 6f 6e 74 65 6e | 74 73 3f e8 54 68 69 73 |s conten|ts?.This|
|000007c0| 20 6e 61 6d 65 20 63 61 | 6e 6e 6f 74 20 62 65 20 | name ca|nnot be |
|000007d0| 75 73 65 64 20 69 6e 20 | 61 20 63 61 6c 63 75 6c |used in |a calcul|
|000007e0| 61 74 69 6f 6e 20 66 6f | 72 6d 75 6c 61 20 62 65 |ation fo|rmula be|
|000007f0| 63 61 75 73 65 20 69 74 | 0d 20 20 2d 20 63 6f 6e |cause it|.  - con|
|00000800| 74 61 69 6e 73 3a 20 2b | 20 2d 20 2a 20 2f 20 5e |tains: +| - * / ^|
|00000810| 20 26 20 3d 20 3c 20 3e | 20 28 20 2c 20 29 20 22 | & = < >| ( , ) "|
|00000820| 20 3a 3a 0d 20 20 2d 20 | 63 6f 6e 74 61 69 6e 73 | ::.  - |contains|
|00000830| 3a 20 41 4e 44 2c 20 4f | 52 2c 20 58 4f 52 2c 20 |: AND, O|R, XOR, |
|00000840| 4e 4f 54 2c 20 6f 72 0d | 20 20 2d 20 62 65 67 69 |NOT, or.|  - begi|
|00000850| 6e 73 20 77 69 74 68 20 | 61 20 64 69 67 69 74 20 |ns with |a digit |
|00000860| 6f 72 20 61 20 70 65 72 | 69 6f 64 2c 20 6f 72 0d |or a per|iod, or.|
|00000870| 20 20 2d 20 68 61 73 20 | 74 68 65 20 73 61 6d 65 |  - has |the same|
|00000880| 20 6e 61 6d 65 20 61 73 | 20 61 20 66 75 6e 63 74 | name as| a funct|
|00000890| 69 6f 6e 2e 0d 50 72 6f | 63 65 65 64 20 61 6e 79 |ion..Pro|ceed any|
|000008a0| 77 61 79 3f c0 57 68 65 | 6e 20 63 68 61 6e 67 69 |way?.Whe|n changi|
|000008b0| 6e 67 20 74 68 65 20 66 | 69 65 6c 64 20 74 79 70 |ng the f|ield typ|
|000008c0| 65 20 66 72 6f 6d 20 54 | 65 78 74 20 74 6f 20 4e |e from T|ext to N|
|000008d0| 75 6d 62 65 72 2c 20 44 | 61 74 65 2c 20 6f 72 20 |umber, D|ate, or |
|000008e0| 54 69 6d 65 2c 20 46 69 | 6c 65 4d 61 6b 65 72 20 |Time, Fi|leMaker |
|000008f0| 77 69 6c 6c 20 70 75 74 | 20 74 68 65 20 64 61 74 |will put| the dat|
|00000900| 61 20 6f 6e 20 6f 6e 65 | 20 6c 69 6e 65 2e 20 20 |a on one| line.  |
|00000910| 41 6e 79 20 64 61 74 61 | 20 61 66 74 65 72 20 74 |Any data| after t|
|00000920| 68 65 20 66 69 72 73 74 | 20 32 35 35 20 63 68 61 |he first| 255 cha|
|00000930| 72 61 63 74 65 72 73 20 | 77 69 6c 6c 20 62 65 20 |racters |will be |
|00000940| 70 65 72 6d 61 6e 65 6e | 74 6c 79 20 64 65 6c 65 |permanen|tly dele|
|00000950| 74 65 64 2e 20 20 50 72 | 6f 63 65 65 64 20 61 6e |ted.  Pr|oceed an|
|00000960| 79 77 61 79 3f 95 57 68 | 65 6e 20 63 68 61 6e 67 |yway?.Wh|en chang|
|00000970| 69 6e 67 20 74 68 65 20 | 66 69 65 6c 64 20 74 79 |ing the |field ty|
|00000980| 70 65 20 74 6f 20 43 61 | 6c 63 75 6c 61 74 69 6f |pe to Ca|lculatio|
|00000990| 6e 20 6f 72 20 53 75 6d | 6d 61 72 79 2c 20 46 69 |n or Sum|mary, Fi|
|000009a0| 6c 65 4d 61 6b 65 72 20 | 77 69 6c 6c 20 72 65 70 |leMaker |will rep|
|000009b0| 6c 61 63 65 20 61 6e 79 | 20 64 61 74 61 20 69 6e |lace any| data in|
|000009c0| 20 74 68 65 20 66 69 65 | 6c 64 20 77 69 74 68 20 | the fie|ld with |
|000009d0| 74 68 65 20 72 65 73 75 | 6c 74 20 6f 66 20 74 68 |the resu|lt of th|
|000009e0| 65 20 66 6f 72 6d 75 6c | 61 2e 20 20 50 72 6f 63 |e formul|a.  Proc|
|000009f0| 65 65 64 20 61 6e 79 77 | 61 79 3f 60 57 68 65 6e |eed anyw|ay?`When|
|00000a00| 20 63 68 61 6e 67 69 6e | 67 20 74 6f 20 6f 72 20 | changin|g to or |
|00000a10| 66 72 6f 6d 20 61 20 43 | 6f 6e 74 61 69 6e 65 72 |from a C|ontainer|
|00000a20| 20 66 69 65 6c 64 2c 20 | 61 6c 6c 20 64 61 74 61 | field, |all data|
|00000a30| 20 69 6e 20 74 68 65 20 | 66 69 65 6c 64 20 77 69 | in the |field wi|
|00000a40| 6c 6c 20 62 65 20 6c 6f | 73 74 2e 20 20 50 72 6f |ll be lo|st.  Pro|
|00000a50| 63 65 65 64 20 61 6e 79 | 77 61 79 3f b1 54 68 65 |ceed any|way?.The|
|00000a60| 20 66 69 65 6c 64 20 22 | 5e 30 22 20 68 61 73 20 | field "|^0" has |
|00000a70| 62 65 65 6e 20 64 65 66 | 69 6e 65 64 20 74 6f 20 |been def|ined to |
|00000a80| 68 61 76 65 20 6d 6f 72 | 65 20 72 65 70 65 74 69 |have mor|e repeti|
|00000a90| 74 69 6f 6e 73 20 74 68 | 61 6e 20 74 68 65 20 66 |tions th|an the f|
|00000aa0| 69 65 6c 64 20 22 5e 31 | 22 20 69 6e 20 74 68 69 |ield "^1|" in thi|
|00000ab0| 73 20 66 69 6c 65 2e 20 | 20 41 73 20 61 20 72 65 |s file. | As a re|
|00000ac0| 73 75 6c 74 2c 20 73 6f | 6d 65 20 64 61 74 61 20 |sult, so|me data |
|00000ad0| 6d 61 79 20 6e 6f 74 20 | 62 65 20 63 6f 70 69 65 |may not |be copie|
|00000ae0| 64 20 77 68 65 6e 20 61 | 20 6c 6f 6f 6b 75 70 20 |d when a| lookup |
|00000af0| 69 73 20 70 65 72 66 6f | 72 6d 65 64 2e 20 20 50 |is perfo|rmed.  P|
|00000b00| 72 6f 63 65 65 64 20 61 | 6e 79 77 61 79 3f 5d 57 |roceed a|nyway?]W|
|00000b10| 68 65 6e 20 63 68 61 6e | 67 69 6e 67 20 74 6f 20 |hen chan|ging to |
|00000b20| 6f 72 20 66 72 6f 6d 20 | 61 20 47 6c 6f 62 61 6c |or from |a Global|
|00000b30| 20 66 69 65 6c 64 2c 20 | 61 6c 6c 20 64 61 74 61 | field, |all data|
|00000b40| 20 69 6e 20 74 68 65 20 | 66 69 65 6c 64 20 77 69 | in the |field wi|
|00000b50| 6c 6c 20 62 65 20 6c 6f | 73 74 2e 20 20 50 72 6f |ll be lo|st.  Pro|
|00000b60| 63 65 65 64 20 61 6e 79 | 77 61 79 3f 55 54 68 65 |ceed any|way?UThe|
|00000b70| 20 73 75 6d 6d 61 72 69 | 7a 65 64 20 66 69 65 6c | summari|zed fiel|
|00000b80| 64 20 6d 75 73 74 20 62 | 65 20 61 20 54 65 78 74 |d must b|e a Text|
|00000b90| 2c 20 4e 75 6d 62 65 72 | 2c 20 44 61 74 65 2c 20 |, Number|, Date, |
|00000ba0| 54 69 6d 65 2c 20 47 6c | 6f 62 61 6c 20 6f 72 20 |Time, Gl|obal or |
|00000bb0| 43 61 6c 63 75 6c 61 74 | 69 6f 6e 20 66 69 65 6c |Calculat|ion fiel|
|00000bc0| 64 2e 29 54 68 65 20 72 | 65 6c 61 74 69 6f 6e 73 |d.)The r|elations|
|00000bd0| 68 69 70 20 6e 61 6d 65 | 20 22 5e 31 22 20 69 73 |hip name| "^1" is|
|00000be0| 20 6e 6f 74 20 75 6e 69 | 71 75 65 2e 7c 52 65 6c | not uni|que.|Rel|
|00000bf0| 61 74 69 6f 6e 73 68 69 | 70 20 6e 61 6d 65 73 20 |ationshi|p names |
|00000c00| 6d 75 73 74 20 62 65 20 | 62 65 74 77 65 65 6e 20 |must be |between |
|00000c10| 31 20 61 6e 64 20 36 30 | 20 63 68 61 72 61 63 74 |1 and 60| charact|
|00000c20| 65 72 73 20 61 6e 64 20 | 6d 61 79 20 6e 6f 74 20 |ers and |may not |
|00000c30| 63 6f 6e 74 61 69 6e 20 | 61 20 22 3a 22 2e 20 20 |contain |a ":".  |
|00000c40| 50 6c 65 61 73 65 20 74 | 79 70 65 20 69 6e 20 61 |Please t|ype in a|
|00000c50| 20 76 61 6c 69 64 20 72 | 65 6c 61 74 69 6f 6e 73 | valid r|elations|
|00000c60| 68 69 70 20 6e 61 6d 65 | 2e 85 56 61 6c 75 65 20 |hip name|..Value |
|00000c70| 6c 69 73 74 20 6e 61 6d | 65 73 20 6d 75 73 74 20 |list nam|es must |
|00000c80| 62 65 20 62 65 74 77 65 | 65 6e 20 31 20 61 6e 64 |be betwe|en 1 and|
|00000c90| 20 36 30 20 63 68 61 72 | 61 63 74 65 72 73 20 61 | 60 char|acters a|
|00000ca0| 6e 64 20 6d 75 73 74 20 | 62 65 20 75 6e 69 71 75 |nd must |be uniqu|
|00000cb0| 65 2e 20 20 50 6c 65 61 | 73 65 20 74 79 70 65 20 |e.  Plea|se type |
|00000cc0| 61 20 76 61 6c 69 64 20 | 6e 61 6d 65 20 62 65 66 |a valid |name bef|
|00000cd0| 6f 72 65 20 63 6c 69 63 | 6b 69 6e 67 20 74 68 65 |ore clic|king the|
|00000ce0| 20 63 72 65 61 74 65 20 | 62 75 74 74 6f 6e 2e 50 | create |button.P|
|00000cf0| 50 65 72 6d 61 6e 65 6e | 74 6c 79 20 64 65 6c 65 |Permanen|tly dele|
|00000d00| 74 69 6e 67 20 22 5e 31 | 22 20 77 69 6c 6c 20 69 |ting "^1|" will i|
|00000d10| 6e 76 61 6c 69 64 61 74 | 65 20 61 6c 6c 20 72 65 |nvalidat|e all re|
|00000d20| 66 65 72 65 6e 63 65 73 | 20 74 6f 20 69 74 2e 20 |ferences| to it. |
|00000d30| 20 50 72 6f 63 65 65 64 | 20 61 6e 79 77 61 79 3f | Proceed| anyway?|
|00000d40| 57 54 68 65 20 66 69 65 | 6c 64 20 74 79 70 65 20 |WThe fie|ld type |
|00000d50| 6f 66 20 22 5e 30 22 20 | 63 61 6e 6e 6f 74 20 62 |of "^0" |cannot b|
|00000d60| 65 20 63 68 61 6e 67 65 | 64 20 62 65 63 61 75 73 |e change|d becaus|
|00000d70| 65 20 22 5e 30 22 20 69 | 73 20 75 73 65 64 20 62 |e "^0" i|s used b|
|00000d80| 79 20 74 68 65 20 72 65 | 6c 61 74 69 6f 6e 73 68 |y the re|lationsh|
|00000d90| 69 70 20 22 5e 31 22 2e | a2 54 68 65 20 63 61 6c |ip "^1".|.The cal|
|00000da0| 63 75 6c 61 74 69 6f 6e | 20 22 5e 31 22 20 63 61 |culation| "^1" ca|
|00000db0| 6e 6e 6f 74 20 62 65 20 | 73 74 6f 72 65 64 20 6f |nnot be |stored o|
|00000dc0| 72 20 69 6e 64 65 78 65 | 64 20 62 65 63 61 75 73 |r indexe|d becaus|
|00000dd0| 65 20 69 74 20 72 65 66 | 65 72 65 6e 63 65 73 20 |e it ref|erences |
|00000de0| 61 20 72 65 6c 61 74 65 | 64 20 66 69 65 6c 64 2c |a relate|d field,|
|00000df0| 20 61 20 47 6c 6f 62 61 | 6c 20 66 69 65 6c 64 2c | a Globa|l field,|
|00000e00| 20 61 20 53 75 6d 6d 61 | 72 79 20 66 69 65 6c 64 | a Summa|ry field|
|00000e10| 20 6f 72 20 61 6e 20 75 | 6e 73 74 6f 72 65 64 20 | or an u|nstored |
|00000e20| 43 61 6c 63 75 6c 61 74 | 69 6f 6e 20 69 6e 20 69 |Calculat|ion in i|
|00000e30| 74 73 20 66 6f 72 6d 75 | 6c 61 2e 5a 54 68 69 73 |ts formu|la.ZThis|
|00000e40| 20 72 65 6c 61 74 69 6f | 6e 73 68 69 70 20 77 69 | relatio|nship wi|
|00000e50| 6c 6c 20 6e 6f 74 20 77 | 6f 72 6b 20 62 65 63 61 |ll not w|ork beca|
|00000e60| 75 73 65 20 74 68 65 20 | 66 69 65 6c 64 20 22 5e |use the |field "^|
|00000e70| 31 22 20 63 61 6e 6e 6f | 74 20 62 65 20 69 6e 64 |1" canno|t be ind|
|00000e80| 65 78 65 64 2e 20 20 50 | 72 6f 63 65 65 64 20 61 |exed.  P|roceed a|
|00000e90| 6e 79 77 61 79 3f 80 22 | 5e 30 22 2c 20 77 68 69 |nyway?."|^0", whi|
|00000ea0| 63 68 20 69 73 20 61 20 | 6d 61 74 63 68 20 66 69 |ch is a |match fi|
|00000eb0| 65 6c 64 20 69 6e 20 74 | 68 69 73 20 72 65 6c 61 |eld in t|his rela|
|00000ec0| 74 69 6f 6e 73 68 69 70 | 2c 20 69 73 20 61 6c 73 |tionship|, is als|
|00000ed0| 6f 20 74 68 65 20 64 65 | 73 74 69 6e 61 74 69 6f |o the de|stinatio|
|00000ee0| 6e 20 6f 66 20 61 20 6c | 6f 6f 6b 75 70 2e 20 54 |n of a l|ookup. T|
|00000ef0| 68 69 73 20 63 69 72 63 | 75 6c 61 72 20 64 65 66 |his circ|ular def|
|00000f00| 69 6e 69 74 69 6f 6e 20 | 69 73 20 6e 6f 74 20 61 |inition |is not a|
|00000f10| 6c 6c 6f 77 65 64 2e 6f | 43 68 65 63 6b 69 6e 67 |llowed.o|Checking|
|00000f20| 20 66 6f 72 20 75 6e 69 | 71 75 65 20 6f 72 20 65 | for uni|que or e|
|00000f30| 78 69 73 74 69 6e 67 20 | 76 61 6c 75 65 73 20 77 |xisting |values w|
|00000f40| 69 6c 6c 20 6e 6f 74 20 | 77 6f 72 6b 20 62 65 63 |ill not |work bec|
|00000f50| 61 75 73 65 20 74 68 65 | 20 66 69 65 6c 64 20 22 |ause the| field "|
|00000f60| 5e 31 22 20 63 61 6e 6e | 6f 74 20 62 65 20 69 6e |^1" cann|ot be in|
|00000f70| 64 65 78 65 64 2e 20 20 | 50 72 6f 63 65 65 64 20 |dexed.  |Proceed |
|00000f80| 61 6e 79 77 61 79 3f 5d | 54 68 69 73 20 72 65 6c |anyway?]|This rel|
|00000f90| 61 74 69 6f 6e 73 68 69 | 70 20 77 69 6c 6c 20 6e |ationshi|p will n|
|00000fa0| 6f 74 20 77 6f 72 6b 20 | 62 65 63 61 75 73 65 20 |ot work |because |
|00000fb0| 74 68 65 20 66 69 65 6c | 64 20 22 5e 31 22 20 69 |the fiel|d "^1" i|
|00000fc0| 73 20 61 20 63 6f 6e 74 | 61 69 6e 65 72 20 66 69 |s a cont|ainer fi|
|00000fd0| 65 6c 64 2e 20 20 50 72 | 6f 63 65 65 64 20 61 6e |eld.  Pr|oceed an|
|00000fe0| 79 77 61 79 3f 60 22 5e | 31 22 20 61 6e 64 20 22 |yway?`"^|1" and "|
|00000ff0| 5e 30 22 20 20 61 72 65 | 20 69 6e 63 6f 6d 70 61 |^0"  are| incompa|
|00001000| 74 69 62 6c 65 20 66 69 | 65 6c 64 73 2e 20 20 4f |tible fi|elds.  O|
|00001010| 6e 6c 79 20 6f 6e 65 20 | 6f 66 20 74 68 65 6d 20 |nly one |of them |
|00001020| 69 73 20 61 20 63 6f 6e | 74 61 69 6e 65 72 20 66 |is a con|tainer f|
|00001030| 69 65 6c 64 2e 20 20 50 | 72 6f 63 65 65 64 20 61 |ield.  P|roceed a|
|00001040| 6e 79 77 61 79 3f       |                         |nyway?  |        |
+--------+-------------------------+-------------------------+--------+--------+